<%if ?first_page%>

Welcome to the Washington State Wines database.

The Washington State Wines database contains information about wines produced in Washington state.
Use the DataSpot search capabilities to locate wines according to your own criteria.

See the schema for the tables and the links of the original database.

<%endif%> <%OPEN ?answer?main_item%> <%USE TEMPLATE=MAIN_FULL_DISPLAY Domain=?domain%> <%/OPEN%> <%OPEN ?answer?items%>

Reasoning:

<%/OPEN%>
<%if ?answer?prev_answer%> <%else%> <%if ?first_page%> <%else%> <%endif%> <%endif%> <%if ?answer?next_answer%> <%else%> <%if ?first_page%> <%else%> <%endif%> <%endif%> <%if ?first_page%> <%else%> <%endif%>
[Previous Answer][Previous Answer][Next Answer][Next Answer][New Search...]
<%if ?first_page%> <%endif%> <%if ?first_page%> <%endif%>
Free Format Search Guided Search
DataSpot.com <%if ?first_page%> <%else%> <%endif%>
<%LOOP ?query?answers%> <%if ?first%>Answers:
<%OPEN ?query%> <%if ?done%> <%if ?answers?ct GE 120%> [Answer limit reached (120)] <%else%> [No more answers] <%endif%> <%else%> [More Answers] <%endif%> <%/OPEN%> <%if ?first_page%> <%else%> [New Search...] <%endif%>
<%endif%> <%else%> <%OPEN ?query%> <%if ?done%> No answers <%else%> No answers located yet
<%OPEN ?query%> <%if ?done%> <%if ?answers?ct GE 120%> [Answer limit reached (120)] <%else%> [No more answers] <%endif%> <%else%> [More Answers] <%endif%> <%/OPEN%> <%if ?first_page%> <%else%> [New Search...] <%endif%>
<%endif%> <%/OPEN%> <%/LOOP%>

<%!==Title display for table Appellations==================================%>

<%DEFINE TEMPLATE=TITLE_DISPLAY Domain=2%> Appellation: <%F [Appellation Name]%> <%/DEFINE%>

<%!==Brief display for table Appellations==================================%>

<%DEFINE TEMPLATE=BRIEF_DISPLAY Domain=2%> Appellation: <%F [Appellation Name]%> <%/DEFINE%>

<%!==Full display for table Appellations===================================%>

<%DEFINE TEMPLATE=MAIN_FULL_DISPLAY Domain=2%> Appellation: <%F [Appellation Name]%>

State/Province:<%F [State/Province ID].[State/Province Name]%>
Country:<%F [Country ID].[Country Name]%>
<%/DEFINE%>

<%!==Title display for table Awards========================================%>

<%DEFINE TEMPLATE=TITLE_DISPLAY Domain=3%> Award: <%F [Award Name]%> <%/DEFINE%>

<%!==Brief display for table Awards========================================%>

<%DEFINE TEMPLATE=BRIEF_DISPLAY Domain=3%> Award: <%F [Award Name]%> <%/DEFINE%>

<%!==Full display for table Awards=========================================%>

<%DEFINE TEMPLATE=MAIN_FULL_DISPLAY Domain=3%> Award: <%F [Award Name]%>

Wine: <%F [Wine ID].[Winery ID].[Winery Name]%>  <%F [Wine ID].[Wine Name]%>
Vintage:<%F [Vintage]%>
<%/DEFINE%>

<%!==Title display for table Country=======================================%>

<%DEFINE TEMPLATE=TITLE_DISPLAY Domain=5%> Country: <%F [Country Name]%> <%/DEFINE%>

<%!==Brief display for table Country=======================================%>

<%DEFINE TEMPLATE=BRIEF_DISPLAY Domain=5%> Country: <%F [Country Name]%> <%/DEFINE%>

<%!==Full display for table Country========================================%>

<%DEFINE TEMPLATE=MAIN_FULL_DISPLAY Domain=5%> Country: <%F [Country Name]%>

Country Name:<%F [Country Name]%>
<%/DEFINE%>

<%!==Title display for table Food Categories===============================%>

<%DEFINE TEMPLATE=TITLE_DISPLAY Domain=6%> Food Category: <%F [Food Category Name]%> <%/DEFINE%>

<%!==Brief display for table Food Categories===============================%>

<%DEFINE TEMPLATE=BRIEF_DISPLAY Domain=6%> Food Category: <%F [Food Category Name]%> <%/DEFINE%>

<%!==Full display for table Food Categories================================%>

<%DEFINE TEMPLATE=MAIN_FULL_DISPLAY Domain=6%> Food Category: <%F [Food Category Name]%>

<%F [Description]%>
<%OPEN ?key_field?field_facts[7]%> <%if ?get_env[DD] eq 7%><%else%><%endif%>
Related Foods+Wines (<%T ?ct%> items)[Hide][Display]
<%if ?get_env[DD] eq 7%> <%begindetail%> <%if ?first%> <%endif%> <%enddetail%>
<%F [Food Category ID].[Food Category Name]%>+ <%F [Wine ID].[Wine Name]%>
<%endif%> <%/OPEN%>
<%/DEFINE%>

<%!==Title display for table Foods+Wines===================================%>

<%DEFINE TEMPLATE=TITLE_DISPLAY Domain=7%> Foods+Wine: <%F [Wine ID].[Wine Name]%>+<%F [Food Category ID].[Food Category Name]%> <%/DEFINE%>

<%!==Brief display for table Foods+Wines===================================%>

<%DEFINE TEMPLATE=BRIEF_DISPLAY Domain=7%> Foods+Wine:  <%F [Food Category ID].[Food Category Name]%>+ <%F [Wine ID].[Wine Name]%> <%/DEFINE%>

<%!==Full display for table Foods+Wines====================================%>

<%DEFINE TEMPLATE=MAIN_FULL_DISPLAY Domain=7%> Foods+Wine: <%F [Food Category ID].[Food Category Name]%>+<%F [Wine ID].[Wine Name]%>

Wine:<%F [Wine ID].[Wine Name]%>  <%F [Wine ID].[Vintage]%>  <%F [Wine ID].[Winery ID].[Winery Name]%>
Food Category:<%F [Food Category ID].[Food Category Name]%>
Notes:<%F [Notes]%>
<%/DEFINE%>

<%!==Title display for table Grapes========================================%>

<%DEFINE TEMPLATE=TITLE_DISPLAY Domain=8%> Grape: <%F [Grape Name]%> <%/DEFINE%>

<%!==Brief display for table Grapes========================================%>

<%DEFINE TEMPLATE=BRIEF_DISPLAY Domain=8%> Grape: <%F [Grape Name]%> <%/DEFINE%>

<%!==Full display for table Grapes=========================================%>

<%DEFINE TEMPLATE=MAIN_FULL_DISPLAY Domain=8%> Grape: <%F [Grape Name]%>

Pronounciation:<%F [Pronounciation]%>
<%F [Description]%>
<%OPEN ?key_field?field_facts[9]%> <%if ?get_env[DD] eq 9%><%else%><%endif%>
Related Grapes+Wines (<%T ?ct%> items)[Hide][Display]
<%if ?get_env[DD] eq 9%> <%begindetail%> <%if ?first%> <%endif%> <%enddetail%>
<%F [Grape ID].[Grape Name]%>+ <%F [Wine ID].[Wine Name]%>
<%endif%> <%/OPEN%>
<%/DEFINE%>

<%!==Title display for table Grapes+Wines==================================%>

<%DEFINE TEMPLATE=TITLE_DISPLAY Domain=9%> Grapes+Wine: <%F [Grape ID].[Grape Name]%>+<%F [Wine ID].[Wine Name]%> <%/DEFINE%>

<%!==Brief display for table Grapes+Wines==================================%>

<%DEFINE TEMPLATE=BRIEF_DISPLAY Domain=9%> Grapes+Wine:  <%F [Grape ID].[Grape Name]%> +<%F [Wine ID].[Wine Name]%> <%/DEFINE%>

<%!==Full display for table Grapes+Wines===================================%>

<%DEFINE TEMPLATE=MAIN_FULL_DISPLAY Domain=9%> Grapes+Wine: <%F [Grape ID].[Grape Name]%> /<%F [Wine ID].[Wine Name]%>

Wine:  <%F [Wine ID].[Wine Name]%>  <%F [Wine ID].[Vintage]%>  <%F [Wine ID].[Winery ID].[Winery Name]%>
Grape:<%F [Grape ID].[Grape Name]%>
% Used:<%F [% Used]%>
<%/DEFINE%>

<%!==Title display for table Regions=======================================%>

<%DEFINE TEMPLATE=TITLE_DISPLAY Domain=11%> Region: <%F [Region Name]%> <%/DEFINE%>

<%!==Brief display for table Regions=======================================%>

<%DEFINE TEMPLATE=BRIEF_DISPLAY Domain=11%> Region: <%F [Region Name]%> <%/DEFINE%>

<%!==Full display for table Regions========================================%>

<%DEFINE TEMPLATE=MAIN_FULL_DISPLAY Domain=11%> Region: <%F [Region Name]%>

<%F [Description]%>
State/Province:<%F [State/Province ID].[State/Province Name]%>
<%OPEN ?key_field?field_facts[19]%> <%if ?get_env[DD] eq 19%><%else%><%endif%>
Related Wineries (<%T ?ct%> items)[Hide][Display]
<%if ?get_env[DD] eq 19%> <%begindetail%> <%if ?first%> <%endif%> <%enddetail%>
Winery Name
<%F [Winery Name]%>
<%endif%> <%/OPEN%>
<%/DEFINE%>

<%!==Title display for table State/Province================================%>

<%DEFINE TEMPLATE=TITLE_DISPLAY Domain=12%> State/Province: <%F [State/Province Name]%> <%/DEFINE%>

<%!==Brief display for table State/Province================================%>

<%DEFINE TEMPLATE=BRIEF_DISPLAY Domain=12%> State/Province: <%F [State/Province Name]%> <%/DEFINE%>

<%!==Full display for table State/Province=================================%>

<%DEFINE TEMPLATE=MAIN_FULL_DISPLAY Domain=12%> State/Province: <%F [State/Province Name]%>

Country:<%F [Country ID].[Country Name]%>
<%/DEFINE%>

<%!==Title display for table Wine Colors===================================%>

<%DEFINE TEMPLATE=TITLE_DISPLAY Domain=15%> Wine Color: <%F [Color Name]%> <%/DEFINE%>

<%!==Brief display for table Wine Colors===================================%>

<%DEFINE TEMPLATE=BRIEF_DISPLAY Domain=15%> Wine Color: <%F [Color Name]%> <%/DEFINE%>

<%!==Full display for table Wine Colors====================================%>

<%DEFINE TEMPLATE=MAIN_FULL_DISPLAY Domain=15%> Wine Color: <%F [Color Name]%>

<%F [Description]%>
<%/DEFINE%>

<%!==Title display for table Wine Types====================================%>

<%DEFINE TEMPLATE=TITLE_DISPLAY Domain=18%> Wine Type: <%F [Type Name]%> <%/DEFINE%>

<%!==Brief display for table Wine Types====================================%>

<%DEFINE TEMPLATE=BRIEF_DISPLAY Domain=18%> Wine Type: <%F [Type Name]%> <%/DEFINE%>

<%!==Full display for table Wine Types=====================================%>

<%DEFINE TEMPLATE=MAIN_FULL_DISPLAY Domain=18%> Wine Type: <%F [Type Name]%>

<%F [Description]%>
<%/DEFINE%>

<%!==Title display for table Wineries======================================%>

<%DEFINE TEMPLATE=TITLE_DISPLAY Domain=19%> Winery: <%F [Winery Name]%> <%/DEFINE%>

<%!==Brief display for table Wineries======================================%>

<%DEFINE TEMPLATE=BRIEF_DISPLAY Domain=19%> Winery: <%F [Winery Name]%> <%/DEFINE%>

<%!==Full display for table Wineries=======================================%>

<%DEFINE TEMPLATE=MAIN_FULL_DISPLAY Domain=19%> Winery: <%F [Winery Name]%>

Founded:<%F [Founded]%>
Owner:<%F [Owner]%>
Region:<%F [Region ID].[Region Name]%>
Address: <%F [Address]%>  <%F [City]%>  <%F [State/Province ID].[State/Province Name]%>  <%F [Postal Code]%>  <%F [Country ID].[Country Name]%>
Phone:<%F [Phone]%>
<%F [Comments]%>

<%L ?fields["Tours Available"]%>--- Tours Available ---<%BREAK%> <%ELSE%>--- No Tours ---<%/L%>
<%OPEN ?key_field?field_facts[20]%> <%if ?get_env[DD] eq 20%><%else%><%endif%>
Related Wines (<%T ?ct%> items)[Hide][Display]
<%if ?get_env[DD] eq 20%> <%begindetail%> <%if ?first%> <%endif%> <%enddetail%>
Wine NameVintage
<%F [Wine Name]%> <%F [Vintage]%>
<%endif%> <%/OPEN%>
<%/DEFINE%>

<%!==Title display for table Wines=========================================%>

<%DEFINE TEMPLATE=TITLE_DISPLAY Domain=20%> <%F [Wine Name]%>  <%F [Vintage]%>  <%F [Winery ID].[Winery Name]%> <%/DEFINE%>

<%!==Brief display for table Wines=========================================%>

<%DEFINE TEMPLATE=BRIEF_DISPLAY Domain=20%> Wine: <%F [Wine Name]%>  <%F [Vintage]%>  <%F [Winery ID].[Winery Name]%><%/DEFINE%>

<%!==Full display for table Wines==========================================%>

<%DEFINE TEMPLATE=MAIN_FULL_DISPLAY Domain=20%> <%F [Wine Name]%> <%F [Vintage]%>  <%F [Winery ID].[Winery Name]%>

<%F [Color ID].[Color Name]%> <%F [Type ID].[Type Name]%> wine
Appellation: <%F [Appellation ID].[Appellation Name]%>
<%F [% Alcohol]%> * 100% Alcohol
<%F [Comments]%>
 <%OPEN ?key_field?field_facts[9]?elt[0]?fields["Grape ID"]?elt[0]?keyed_item?fields["Grape Name"]?elt[0]%> <%IF "Merlot" c ?value%><%ELSE%> <%IF "Pinot Noir" c ?value%><%ELSE%> <%IF "Sauvignon" c ?value%><%ELSE%> <%IF "Riesling" c ?value%><%ELSE%> <%IF "Chenin Blanc" c ?value%><%ELSE%> <%IF "Cabernet" c ?value%><%ELSE%> <%IF "Chardonnay" c ?value%><%ELSE%> <%IF "Semillon" c ?value%><%ELSE%> <%IF "Sangiove" c ?value%><%ELSE%> <%IF "Gewurztraminer" c ?value%><%ELSE%> <%IF "Syrah" c ?value%><%ELSE%> <%IF "Nebbiolo" c ?value%> <%/IF%><%/IF%><%/IF%><%/IF%><%/IF%><%/IF%><%/IF%><%/IF%><%/IF%><%/IF%><%/IF%><%/IF%> <%/OPEN%>
<%OPEN ?key_field?field_facts[3]%> <%if ?get_env[DD] eq 3%><%else%><%endif%>
Related Awards (<%T ?ct%> items)[Hide][Display]
<%if ?get_env[DD] eq 3%> <%begindetail%> <%if ?first%> <%endif%> <%enddetail%>
Award Name
<%F [Award Name]%>
<%endif%> <%/OPEN%>
<%OPEN ?key_field?field_facts[7]%> <%if ?get_env[DD] eq 7%><%else%><%endif%>
Related Foods+Wines (<%T ?ct%> items)[Hide][Display]
<%if ?get_env[DD] eq 7%> <%begindetail%> <%if ?first%> <%endif%> <%enddetail%>
<%F [Food Category ID].[Food Category Name]%>+ <%F [Wine ID].[Wine Name]%>
<%endif%> <%/OPEN%>
<%OPEN ?key_field?field_facts[9]%> <%if ?get_env[DD] eq 9%><%else%><%endif%>
Related Grapes+Wines (<%T ?ct%> items)[Hide][Display]
<%if ?get_env[DD] eq 9%> <%begindetail%> <%if ?first%> <%endif%> <%enddetail%>
<%F [Grape ID].[Grape Name]%>/ <%F [Wine ID].[Wine Name]%>
<%endif%> <%/OPEN%>
<%/DEFINE%>

<%!==For displaying only highlighted words embedded in html comments=======%>

<%DEFINE TEMPLATE=HIGHLIGHT_THS%> <%O ?set_highlight_start["> "]%><%/O%> <%O ?set_highlight_end["<%/O%> <%/DEFINE%>

<%!==Thesaurus reasoning===================================================%>

<%DEFINE TEMPLATE=BRIEF_DISPLAY Domain=253%> <%USE TEMPLATE=HIGHLIGHT_THS%> <%OPEN ?main_item%> Thesaurus:  > <%/OPEN%> <%USE TEMPLATE=HIGHLIGHT_STD%> <%/DEFINE%>

<%!==Concept reasoning=====================================================%>

<%DEFINE TEMPLATE=BRIEF_DISPLAY Domain=252%> (Concept Relation) <%/DEFINE%>

<%!==Correction reasoning==================================================%>

<%DEFINE TEMPLATE=BRIEF_DISPLAY Domain=246%> <%USE TEMPLATE=HIGHLIGHT_THS%> <%OPEN ?main_item%> Correction:  > <%/OPEN%> <%USE TEMPLATE=HIGHLIGHT_STD%> <%/DEFINE%>

<%!==Soundex reasoning=====================================================%>

<%DEFINE TEMPLATE=BRIEF_DISPLAY Domain=247%> <%USE TEMPLATE=HIGHLIGHT_THS%> <%OPEN ?main_item%> Soundex:  > <%/OPEN%> <%USE TEMPLATE=HIGHLIGHT_STD%> <%/DEFINE%>

<%!==Subpart reasoning=====================================================%>

<%DEFINE TEMPLATE=BRIEF_DISPLAY Domain=249%> <%USE TEMPLATE=HIGHLIGHT_THS%> <%OPEN ?main_item%> Part of:  > <%/OPEN%> <%USE TEMPLATE=HIGHLIGHT_STD%> <%/DEFINE%>

<%!==Highlighting Templates================================================%>

<%DEFINE TEMPLATE=HIGHLIGHT_STD%> <%O ?set_highlight_start[""]%><%/O%> <%O ?set_highlight_end[""]%><%/O%> <%/DEFINE%> <%DEFINE TEMPLATE=HIGHLIGHT_OFF%> <%O ?set_highlight_start[]%><%/O%> <%O ?set_highlight_end[]%><%/O%> <%/DEFINE%>